package com.hone.honewed.dao.zoneWed;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.eig.common.entity.homepageentity.prefecture.EduCourse;
import com.eig.common.entity.homepageentity.prefecture.TbZone;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author ：YQ袁
 * @date ：Created in 2022/12/27 17:06
 * @description：
 * @modified By：
 * @version:
 */
public interface ZoneWedDao extends BaseMapper<TbZone> {
   @Select("select a.zone_desc,a.zone_name, c.* from tb_zone a join tb_zone_course b on a.id=b.zone_id join edu_course c on b.course_id = c.id where a.id =${id} and c.is_deleted=0 and c.status='Normal'")
    List<EduCourse>courseList (String id );

}
